To Automatically Reconcile your Bank Statement using the E Reconcile Option

Select a date in both the Bank Transactions To and Sage Transactions To boxes to filter the transactions that are displayed.

If the transaction is a payment, the amount is displayed here.

This displays the transaction number in your bank account. Tran No displays the transaction number in your Sage Line 50 program.

If the transaction is a receipt, the amount is displayed here.

This displays the transaction reference code that has been entered for both your bank and Sage Line 50 transactions.

When a transaction has been matched, this displays the transaction(s) that was matched against it.

In the list of Sage Line 50 transactions there is an additional list labelled æTypeÆ. This displays the type of transaction. For example BP represents a Bank Payment, SR represents a sales receipt and JC represents a Journal Credit. For a complete list of bank transaction types, see Bank Transaction Types.

This shows if the transaction has been confirmed. Initially set to æNÆ, once the transaction has been confirmed, the field will change to æYÆ.

This shows the date that the transaction was entered onto the system. Note: In Sage Line 50 you can set the program date to a day other than todayÆs date so that a specified date appears on any entered transactions. Therefore some of the Sage transactions may not correspond to the actual day that they were created.

This shows the amount matched against the transaction.

This displays any additional details that were entered when the transaction was created.

This is the statement balance brought forward from the last reconciliation. It should reflect the opening balance on the statement.

Shows the value of the unreconciled transactions in your Sage Line 50 program.

This is the balance of the bank account up to the date entered on the bank reconciliation screen and represents the balance as if all transactions have been cleared.

This box initially shows the Opening Balance figure, but then changes automatically by the value of the transactions you select for reconciliation. As you work through your bank statement reconciling each line, this value should change to match the balance shown by your bank statement. Before you save the reconciliation, this box should show the same balance as the closing balance of your bank statement. If it does not, the opening balance on your next reconciliation will be incorrect.

When you enter the closing balance of your actual bank statement, the Difference box shows the difference between the transactions you have selected for reconciliation and the Statement End. Balance. When you have selected all of your transactions, this displays a zero balance unless you have adjustments to make, e.g. bank charges or interest payments.

Shows the balance from your imported bank statement. You can change this amount from the Amend Bank Statement Details Window.

This option will try to match transactions that have the same reference code and amount automatically.

This option will try to automatically match transactions that have the same reference code.

This option will try to automatically match transactions that have the same amount.

3. Enter the Statement End Date and Statement End Balance details in the relevant boxes, then click OK.

If there are no matching transactions, a message box appears. You will not be able to reconcile your Sage Line 50 and bank transactions using the æAutomaticÆ reconciliation facility. To go back to the Reconciliation window, click OK.

Note: If there is more than one matching transaction the Duplicate Transactions window appears. Select the transaction that you want to match and choose the Confirm button. The window closes and the two selected transactions will be confirmed. If you do not want to confirm the matching transaction but want to carry on with the automatic matching process, click Next. To close the window without matching any transactions, click Cancel.

Matching transactions will be highlighted in green. The æMatched WithÆ column displays the number of the transaction that has been confirmed as a match. The values in the grey boxes will also update to display the values if you choose to confirm this reconciliation.

The matched transactions are removed from the list. You can view your confirmed transactions by selecting View from the option bar and then choosing Confirmed. Only your confirmed transactions will appear, highlighted in grey. Alternatively, you can view every transaction by selecting the View All option.

6. If you want to reconcile the confirmed transactions, click Reconcile. If you do not want to reconcile the confirmed transactions, click Discard to exit from the window without saving any of the matched transactions.

7. Click Yes to reconcile the matched transactions. Click No to stop the reconciliation process and return to the Reconciliation window.

The matched transactions are marked as reconciled in the Bank module and will no longer appear in the list of Sage or bank transactions. If you have accidentally reconciled a transaction in the bank list, it is possible to reverse the reconciliation process so the transaction appears in your bank list by using the Amend Bank Transactions option. For more information see Amending Bank Transactions.

(Bank Transactions/Sage Transactions) To	Payments
No (Tran No.)	Receipts
Ref	Match With
Type	Conf?
Date	Rec Amount
Details	Opening Balance
Uncleared Items	Book Balance at Date
Reconciled Balance	Difference
Statement End Balance